- 01. Course Introduction
- 02. Lesson Introduction
- 03. Data Warehouse: Business Perspective
- 04. Operational vs. Analytical Processes
- 05. Data Warehouse: Technical Perspective
- 06. Dimensional Modeling
- 07. ETL Demo: Step 1 & 2
- 08. Exercise 1: Step 1 & 2
- 09. ETL Demo: Step 3
- 10. Exercise 1: Step 3
- 11. ETL Demo: Step 4
- 12. Exercise 1: Step 4
- 13. ETL Demo: Step 5
- 14. Exercise 1: Step 5
- 15. ETL Demo: Step 6
- 16. Exercise 1: Step 6
- 17. Exercise Solution 1: 3NF to Star Schema
- 18. DWH Architecture: Kimball's Bus Architecture
- 19. DWH Architecture: Independent Data Marts
- 20. DWH Architecture: CIF
- 21. DWH Architecture: Hybrid Bus & CIF
- 22. OLAP Cubes
- 23. OLAP Cubes: Roll-Up and Drill Down
- 24. OLAP Cubes: Slice and Dice
- 25. OLAP Cubes: Query Optimization
- 26. OLAP Cubes Demo: Slicing & Dicing
- 27. Exercise 2: Slicing & Dicing
- 28. OLAP Cubes Demo: Roll-Up
- 29. Exercise 2: Roll-Up & Drill Down
- 30. OLAP Cubes Demo: Grouping Sets
- 31. Exercise 2: Grouping Sets
- 32. OLAP Cubes Demo: CUBE
- 33. Exercise 2: CUBE
- 34. Data Warehouse Technologies
- 35. Demo: Column format in ROLAP
- 36. Exercise 3: Column format in ROLAP